/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1012

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 53 45 54 |CHILD UP|DATE SET|
|00000010| 4e 55 4c 4c 00 20 20 2d | 2d 20 45 52 77 69 6e 20 |NULL.  -|- ERwin |
|00000020| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00000030| 65 0d 0a 20 20 2d 2d 20 | 25 50 61 72 65 6e 74 20 |e..  -- |%Parent |
|00000040| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00000050| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 55 50 44 41 |ld ON CH|ILD UPDA|
|00000060| 54 45 20 53 45 54 20 4e | 55 4c 4c 20 0d 0a 20 20 |TE SET N|ULL ..  |
|00000070| 77 68 65 6e 28 0d 0a 20 | 20 20 20 2d 2d 20 25 25 |when(.. |   -- %%|
|00000080| 4a 6f 69 6e 50 4b 50 4b | 28 64 65 6c 65 74 65 64 |JoinPKPK|(deleted|
|00000090| 2c 69 6e 73 65 72 74 65 | 64 2c 22 20 3c 3e 20 22 |,inserte|d," <> "|
|000000a0| 2c 22 20 6f 72 22 29 20 | 0d 0a 20 20 20 20 25 4a |," or") |..    %J|
|000000b0| 6f 69 6e 50 4b 50 4b 28 | 64 65 6c 65 74 65 64 2c |oinPKPK(|deleted,|
|000000c0| 69 6e 73 65 72 74 65 64 | 2c 22 20 3c 3e 20 22 2c |inserted|," <> ",|
|000000d0| 22 20 6f 72 22 29 0d 0a | 20 20 29 0d 0a 20 20 20 |" or")..|  )..   |
|000000e0| 20 20 20 28 75 70 64 61 | 74 65 20 25 43 68 69 6c |   (upda|te %Chil|
|000000f0| 64 0d 0a 20 20 20 20 20 | 20 20 20 73 65 74 0d 0a |d..     |   set..|
|00000100| 20 20 20 20 20 20 20 20 | 20 20 2d 2d 20 25 25 53 |        |  -- %%S|
|00000110| 65 74 46 4b 28 25 43 68 | 69 6c 64 2c 4e 55 4c 4c |etFK(%Ch|ild,NULL|
|00000120| 29 20 0d 0a 20 20 20 20 | 20 20 20 20 20 20 25 53 |) ..    |      %S|
|00000130| 65 74 46 4b 28 25 43 68 | 69 6c 64 2c 4e 55 4c 4c |etFK(%Ch|ild,NULL|
|00000140| 29 0d 0a 20 20 20 20 20 | 20 20 20 77 68 65 72 65 |)..     |   where|
|00000150| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 2d 2d 20 25 |..      |    -- %|
|00000160| 25 4a 6f 69 6e 50 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinPKP|K(%Child|
|00000170| 2c 69 6e 73 65 72 74 65 | 64 2c 22 20 3d 20 22 2c |,inserte|d," = ",|
|00000180| 22 20 61 6e 64 22 29 20 | 0d 0a 20 20 20 20 20 20 |" and") |..      |
|00000190| 20 20 20 20 25 4a 6f 69 | 6e 50 4b 50 4b 28 25 43 |    %Joi|nPKPK(%C|
|000001a0| 68 69 6c 64 2c 69 6e 73 | 65 72 74 65 64 2c 22 20 |hild,ins|erted," |
|000001b0| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 61 6e 64 20 |= "," an|d") and |
|000001c0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 6e 6f 74 20 |..      |    not |
|000001d0| 65 78 69 73 74 73 20 28 | 0d 0a 20 20 20 20 20 20 |exists (|..      |
|000001e0| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 2a 20 66 |      se|lect * f|
|000001f0| 72 6f 6d 20 25 50 61 72 | 65 6e 74 0d 0a 20 20 20 |rom %Par|ent..   |
|00000200| 20 20 20 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |        | where..|
|00000210| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 2d 2d |        |      --|
|00000220| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 | %%JoinF|KPK(inse|
|00000230| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rted,%Pa|rent," =|
|00000240| 20 22 2c 22 20 61 6e 64 | 22 29 20 0d 0a 20 20 20 | "," and|") ..   |
|00000250| 20 20 20 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e |        |   %Join|
|00000260| 46 4b 50 4b 28 69 6e 73 | 65 72 74 65 64 2c 25 50 |FKPK(ins|erted,%P|
|00000270| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|00000280| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 20 20 29 |d")..   |       )|
|00000290| 0d 0a 20 20 20 20 20 20 | 29 2c 0d 0a 00 1e 27    |..      |),....' |
+--------+-------------------------+-------------------------+--------+--------+